USE [LAFDC]
GO
/****** Object:  Table [dbo].[Adresse]    Script Date: 11/23/2009 22:54:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Adresse](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[prev_id] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[adresse_1] [nvarchar](203) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[adresse_2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CodePostal] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Ville] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Pays] [varchar](6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[created] [datetime] NULL,
	[last_modified] [datetime] NULL,
 CONSTRAINT [PK_Adresse] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF